﻿using System;
using System.Collections.Generic;
using System.Linq;
using System.Text;

namespace _1___NorthwindConnection
{
    class Program
    {
        static void Main(string[] args)
        {
            //var customers =
            //  from c in context.Customers
            //  where c.City == "London"
            //  select c;
            //foreach (var item in customers)
            //{
            //    Console.WriteLine(item.CompanyName);
            //}


            //NorthwindDAO.InsertCustomer(toAdd);

            //var castomers =
            //    from c in context.Customers
            //    where c.CustomerID == "qqqqq"
            //    select c;

            //foreach (Customer c in castomers)
            //{
            //    Console.WriteLine(c.CompanyName);
            //}



            //NorthwindEntities context = new NorthwindEntities();
            //Console.WriteLine(context.Customers.Count());

            //string x = NorthwindDAO.InsertCustomer("BulevartFart2", null, null, null, null, null, null, null, null, null);
            //Console.WriteLine(context.Customers.Count());

            //Console.WriteLine();

            //NorthwindDAO.DeleteCustomer(x);
            //Console.WriteLine(context.Customers.Count());


            //NorthwindDAO.DeleteCustomer("AAAAA");
            //Console.WriteLine(context.Customers.Count());

            //Console.WriteLine();

            NorthwindDAO.ShippedToCanada();

        }
    }  
}
